﻿CREATE TABLE [dbo].[Accounts_User_Roles] (
    [User_GUID]  UNIQUEIDENTIFIER NOT NULL,
    [RoleNumber] INT              NOT NULL,
    CONSTRAINT [PK_Accounts_User_Roles_1] PRIMARY KEY CLUSTERED ([User_GUID] ASC, [RoleNumber] ASC),
    CONSTRAINT [FK_Accounts_User_Roles_Accounts_Roles] FOREIGN KEY ([RoleNumber]) REFERENCES [dbo].[Accounts_Roles] ([RoleNumber]),
    CONSTRAINT [FK_Accounts_User_Roles_Accounts_User] FOREIGN KEY ([User_GUID]) REFERENCES [dbo].[Accounts_User] ([User_GUID])
);

